 <?php include_once("../classeBDD/connectBdd.php");
    $sql = sql::connect();
    $requete = $sql->query('SELECT * FROM region');
    $select_region='  <label><select name="region"  id="region"  class="validate[required]">';
     while($resultat = $sql->fetch_array($requete)) 
        {
          $select_region .='<option value="'.$resultat['id_region'].'">'.$resultat['nom_region'].'</option>';
        }
    $select_region .='</select></label>';
    $select_categori='<label><select name="categorie">';
    
    $requete = $sql->query('SELECT * FROM categorie');
        while($resultat = $sql->fetch_array($requete)) 
           {
              $select_categori .='<option value="'.$resultat['id_categorie'].'">'.$resultat['nom_categorie'].'</option>';    
            }
   $select_categori .='</select></label>';
   $creer_compte='<td>Mot de passe</td>
                <td>
                <input type="password" name="pwd1" />
                </td>
             <td>confirmer Mot de passe</td>
             <td><input type="password" name="pwd2" /></td>';
                
                
                
                ?>